Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gst_record_version table — gstrv

This table enables you to identify when static data is changed and must be deployed. This table is checked every time the deployment data is written to ensure that all data that matches the deployment criteria is written out.

When an item of data on a record changes, the replication trigger on the table checks if the version_data flag on the gsc_entity_mnemonic table is switched on.

If the flag is switched on, a record is written to this table. If a record already exists in the table, the record is updated to indicate that the data has changed by incrementing the version_number_seq and resetting the date, time, and user.

A version_number_seq greater than 0 indicates that the record has been changed locally and might need to be deployed. Once an import is done for a record, the version_number_seq is set back to 0, indicating the data has not been modified since the last import.

When importing data, the import_version_number_seq is used as a validity check. If this number does not match the import_version_number_seq of the data being imported, or the current version_number_seq does not match, there is a potential conflict.

Table 3–19 lists the table’s FLA, fields, and foreign keys.

Table 3–19: gst_record_version table information 

Table FLA	Fields (data type)	Foreign keys
gstrv	record_version_obj (Decimal) entity_mnemonic (Character) key_field_value (Character) version_number_seq (Decimal) version_date (Date) version_time (Integer) version_user (Character) deletion_flag (Logical) import_version_number_seq (Decimal) last_version_number_seq (Decimal) secondary_key_value (Character)	entity_mnemonic record_version_obj

Table 3–20 gives details of the table’s indexes.

Table 3–20: gst_record_version index information 

Index name	Elements	Type
XPKgst_record_version	record_version_obj	Primary Unique
XAK1gst_record_version	entity_mnemonic key_field_value	Unique
XIE1gst_record_version	key_field_value	Nonunique
XIE3gst_record_version	entity_mnemonic version_date version_time	Nonunique
XIE4gst_record_version	entity_mnemonic version_number_seq	Nonunique
XIE5gst_record_version	version_number_seq	Nonunique
XIE6gst_record_version	entity_mnemonic version_number_seq import_version_number_seq	Nonunique
XIE7gst_record_version	entity_mnemonic secondary_key_value	Nonunique